{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Design Sheet","Print 1","Recipe","Standard Recipe Sheet","Mould Sizes","Calculations 2","Batches","Fragrance","Oils","Colourants","Lye","Oils by Fatty Acids List"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Design Sheet","index":1,"n_rows":150,"n_cols":28,"rows_kept":150,"cut":false,"hidden":true,"merged":[[146,24,146,27],[147,24,147,27],[148,24,148,27],[149,24,149,27],[1,2,1,3],[1,6,1,12],[1,14,1,22],[1,24,1,27],[144,24,144,27],[145,24,145,27]]}
[null,"Fat/Oil"]
[null,"Apricot Kernel","Soaping Oils",null,null,null,"Expected Soap Characteristics",null,null,null,null,null,null,null,"Fatty Acid Composition",null,null,null,null,null,null,null,null,null,"Comparison Chart"]
[null,"Avocado","Oil Name","%",null,null,null,"Hardness","Cleansing","Conditioning","Bubbly","Creamy","Longevity",null,"Oil Name","Lauric","Myristic","Palmitic","Stearic","Ricinoleic","Oleic","Linoleic","Linolenic",null,null,"Lower Range","Actual Value","Upper Range"]
[null,"Avocado Butter","Olive",0.35,null,null,{"$f":"O4","v":"Olive"},{"$f":"SUM(P4:S4)","v":5.9499999999999993},{"$f":"SUM(P4:Q4)","v":0},{"$f":"SUM(T4:W4)","v":28.7},{"$f":"SUM(T4,P4:Q4)","v":0},{"$f":"SUM(R4:T4)","v":5.9499999999999993},{"$f":"R4+S4","v":5.9499999999999993},null,{"$f":"C4","v":"Olive"},{"$f":"IF(ISBLANK($C4),0,VLOOKUP($C4,'Oils by Fatty Acids List'!A:B,2))*$D4","v":0},{"$f":"IF(ISBLANK($C4),0,VLOOKUP($C4,'Oils by Fatty Acids List'!A:C,3))*$D4","v":0},{"$f":"IF(ISBLANK($C4),0,VLOOKUP($C4,'Oils by Fatty Acids List'!A:D,4))*$D4","v":4.8999999999999995},{"$f":"IF(ISBLANK($C4),0,VLOOKUP(C4,'Oils by Fatty Acids List'!A:E,5))*$D4","v":1.0499999999999998},{"$f":"IF(ISBLANK($C4),0,VLOOKUP(C4,'Oils by Fatty Acids List'!A:F,6))*$D4","v":0},{"$f":"IF(ISBLANK($C4),0,VLOOKUP(C4,'Oils by Fatty Acids List'!A:G,7))*$D4","v":24.15},{"$f":"IF(ISBLANK($C4),0,VLOOKUP($C4,'Oils by Fatty Acids List'!A:H,8)*$D4)","v":4.1999999999999993},{"$f":"IF(ISBLANK($C4),0,VLOOKUP($C4,'Oils by Fatty Acids List'!A:I,9))*$D4","v":0.35},null,"Max"]
[null,"Babassu, brazil nut","Coconut",0.2,null,null,"Coconut",15.800000000000002,13.400000000000002,2,13.400000000000002,2.4000000000000004,{"$f":"R5+S5","v":2.4000000000000004},null,"Coconut",{"$f":"IF(ISBLANK($C5),0,VLOOKUP($C5,'Oils by Fatty Acids List'!A:B,2))*$D5","v":9.6000000000000014},{"$f":"IF(ISBLANK($C5),0,VLOOKUP($C5,'Oils by Fatty Acids List'!A:C,3))*$D5","v":3.8000000000000003},{"$f":"IF(ISBLANK($C5),0,VLOOKUP($C5,'Oils by Fatty Acids List'!A:D,4))*$D5","v":1.8},{"$f":"IF(ISBLANK($C5),0,VLOOKUP(C5,'Oils by Fatty Acids List'!A:E,5))*$D5","v":0.60000000000000009},{"$f":"IF(ISBLANK($C5),0,VLOOKUP(C5,'Oils by Fatty Acids List'!A:F,6))*$D5","v":0},{"$f":"IF(ISBLANK($C5),0,VLOOKUP(C5,'Oils by Fatty Acids List'!A:G,7))*$D5","v":1.6},{"$f":"IF(ISBLANK($C5),0,VLOOKUP($C5,'Oils by Fatty Acids List'!A:H,8)*$D5)","v":0.4},{"$f":"IF(ISBLANK($C5),0,VLOOKUP($C5,'Oils by Fatty Acids List'!A:I,9))*$D5","v":0},null,"Hardness",29,{"$f":"H12","v":39},54]
[null,"Beeswax","Lard",0.25,null,null,"Lard",10.5,0.25,13,0.25,10.25,10.25,null,"Lard",{"$f":"IF(ISBLANK($C6),0,VLOOKUP($C6,'Oils by Fatty Acids List'!A:B,2))*$D6","v":0},{"$f":"IF(ISBLANK($C6),0,VLOOKUP($C6,'Oils by Fatty Acids List'!A:C,3))*$D6","v":0.25},{"$f":"IF(ISBLANK($C6),0,VLOOKUP($C6,'Oils by Fatty Acids List'!A:D,4))*$D6","v":7},{"$f":"IF(ISBLANK($C6),0,VLOOKUP(C6,'Oils by Fatty Acids List'!A:E,5))*$D6","v":3.25},{"$f":"IF(ISBLANK($C6),0,VLOOKUP(C6,'Oils by Fatty Acids List'!A:F,6))*$D6","v":0},{"$f":"IF(ISBLANK($C6),0,VLOOKUP(C6,'Oils by Fatty Acids List'!A:G,7))*$D6","v":11.5},{"$f":"IF(ISBLANK($C6),0,VLOOKUP($C6,'Oils by Fatty Acids List'!A:H,8)*$D6)","v":1.5},{"$f":"IF(ISBLANK($C6),0,VLOOKUP($C6,'Oils by Fatty Acids List'!A:I,9))*$D6","v":0},null,"Cleansing",12,{"$f":"I12","v":13.650000000000002},22]
[null,"Borage","Shea Butter",0.15,null,null,"Shea Butter",6.75,0,8.1,0,6.75,6.75,null,"Shea Butter",{"$f":"IF(ISBLANK($C7),0,VLOOKUP($C7,'Oils by Fatty Acids List'!A:B,2))*$D7","v":0},{"$f":"IF(ISBLANK($C7),0,VLOOKUP($C7,'Oils by Fatty Acids List'!A:C,3))*$D7","v":0},{"$f":"IF(ISBLANK($C7),0,VLOOKUP($C7,'Oils by Fatty Acids List'!A:D,4))*$D7","v":0.75},{"$f":"IF(ISBLANK($C7),0,VLOOKUP(C7,'Oils by Fatty Acids List'!A:E,5))*$D7","v":6},{"$f":"IF(ISBLANK($C7),0,VLOOKUP(C7,'Oils by Fatty Acids List'!A:F,6))*$D7","v":0},{"$f":"IF(ISBLANK($C7),0,VLOOKUP(C7,'Oils by Fatty Acids List'!A:G,7))*$D7","v":7.1999999999999993},{"$f":"IF(ISBLANK($C7),0,VLOOKUP($C7,'Oils by Fatty Acids List'!A:H,8)*$D7)","v":0.89999999999999991},{"$f":"IF(ISBLANK($C7),0,VLOOKUP($C7,'Oils by Fatty Acids List'!A:I,9))*$D7","v":0},null,"Conditioning",44,{"$f":"J12","v":56.7},69]
[null,"Brazil Nut","Castor",0.05,null,null,"Castor",0,0,4.9000000000000004,4.5,4.5,0,null,"Castor",{"$f":"IF(ISBLANK($C8),0,VLOOKUP($C8,'Oils by Fatty Acids List'!A:B,2))*$D8","v":0},{"$f":"IF(ISBLANK($C8),0,VLOOKUP($C8,'Oils by Fatty Acids List'!A:C,3))*$D8","v":0},{"$f":"IF(ISBLANK($C8),0,VLOOKUP($C8,'Oils by Fatty Acids List'!A:D,4))*$D8","v":0},{"$f":"IF(ISBLANK($C8),0,VLOOKUP(C8,'Oils by Fatty Acids List'!A:E,5))*$D8","v":0},{"$f":"IF(ISBLANK($C8),0,VLOOKUP(C8,'Oils by Fatty Acids List'!A:F,6))*$D8","v":4.5},{"$f":"IF(ISBLANK($C8),0,VLOOKUP(C8,'Oils by Fatty Acids List'!A:G,7))*$D8","v":0.2},{"$f":"IF(ISBLANK($C8),0,VLOOKUP($C8,'Oils by Fatty Acids List'!A:H,8)*$D8)","v":0.2},{"$f":"IF(ISBLANK($C8),0,VLOOKUP($C8,'Oils by Fatty Acids List'!A:I,9))*$D8","v":0},null,"Bubbly",14,{"$f":"K12","v":18.150000000000002},46]
[null,"Camellia",null,null,null,null,0,0,0,0,0,0,0,null,0,{"$f":"IF(ISBLANK($C9),0,VLOOKUP($C9,'Oils by Fatty Acids List'!A:B,2))*$D9","v":0},{"$f":"IF(ISBLANK($C9),0,VLOOKUP($C9,'Oils by Fatty Acids List'!A:C,3))*$D9","v":0},{"$f":"IF(ISBLANK($C9),0,VLOOKUP($C9,'Oils by Fatty Acids List'!A:D,4))*$D9","v":0},{"$f":"IF(ISBLANK($C9),0,VLOOKUP(C9,'Oils by Fatty Acids List'!A:E,5))*$D9","v":0},{"$f":"IF(ISBLANK($C9),0,VLOOKUP(C9,'Oils by Fatty Acids List'!A:F,6))*$D9","v":0},{"$f":"IF(ISBLANK($C9),0,VLOOKUP(C9,'Oils by Fatty Acids List'!A:G,7))*$D9","v":0},{"$f":"IF(ISBLANK($C9),0,VLOOKUP($C9,'Oils by Fatty Acids List'!A:H,8)*$D9)","v":0},{"$f":"IF(ISBLANK($C9),0,VLOOKUP($C9,'Oils by Fatty Acids List'!A:I,9))*$D9","v":0},null,"Creamy",16,{"$f":"L12","v":29.85},48]
[null,"Candelilla Wax",null,null,null,null,0,0,0,0,0,0,0,null,0,{"$f":"IF(ISBLANK($C10),0,VLOOKUP($C10,'Oils by Fatty Acids List'!A:B,2))*$D10","v":0},{"$f":"IF(ISBLANK($C10),0,VLOOKUP($C10,'Oils by Fatty Acids List'!A:C,3))*$D10","v":0},{"$f":"IF(ISBLANK($C10),0,VLOOKUP($C10,'Oils by Fatty Acids List'!A:D,4))*$D10","v":0},{"$f":"IF(ISBLANK($C10),0,VLOOKUP(C10,'Oils by Fatty Acids List'!A:E,5))*$D10","v":0},{"$f":"IF(ISBLANK($C10),0,VLOOKUP(C10,'Oils by Fatty Acids List'!A:F,6))*$D10","v":0},{"$f":"IF(ISBLANK($C10),0,VLOOKUP(C10,'Oils by Fatty Acids List'!A:G,7))*$D10","v":0},{"$f":"IF(ISBLANK($C10),0,VLOOKUP($C10,'Oils by Fatty Acids List'!A:H,8)*$D10)","v":0},{"$f":"IF(ISBLANK($C10),0,VLOOKUP($C10,'Oils by Fatty Acids List'!A:I,9))*$D10","v":0},null,"Longevity",25,{"$f":"M12","v":25.35},50]
[null,"Canola",null,null,null,null,0,0,0,0,0,0,0,null,0,{"$f":"IF(ISBLANK($C11),0,VLOOKUP($C11,'Oils by Fatty Acids List'!A:B,2))*$D11","v":0},{"$f":"IF(ISBLANK($C11),0,VLOOKUP($C11,'Oils by Fatty Acids List'!A:C,3))*$D11","v":0},{"$f":"IF(ISBLANK($C11),0,VLOOKUP($C11,'Oils by Fatty Acids List'!A:D,4))*$D11","v":0},{"$f":"IF(ISBLANK($C11),0,VLOOKUP(C11,'Oils by Fatty Acids List'!A:E,5))*$D11","v":0},{"$f":"IF(ISBLANK($C11),0,VLOOKUP(C11,'Oils by Fatty Acids List'!A:F,6))*$D11","v":0},{"$f":"IF(ISBLANK($C11),0,VLOOKUP(C11,'Oils by Fatty Acids List'!A:G,7))*$D11","v":0},{"$f":"IF(ISBLANK($C11),0,VLOOKUP($C11,'Oils by Fatty Acids List'!A:H,8)*$D11)","v":0},{"$f":"IF(ISBLANK($C11),0,VLOOKUP($C11,'Oils by Fatty Acids List'!A:I,9))*$D11","v":0}]
[null,"Castor","Total %",{"$f":"SUM(D4:D11)","v":1},null,null,"Totals",{"$f":"SUM(H4:H11)","v":39},13.650000000000002,56.7,18.150000000000002,29.85,25.35,null,"Totals",{"$f":"SUM(P4:P11)","v":9.6000000000000014},4.0500000000000007,14.45,10.9,4.5,44.650000000000006,7.2,0.35]
[null,"Chicken Fat",null,null,null,null,"% Total",{"$f":"H12/(SUM($H$4:$M$11))","v":0.2134646962233169},7.4712643678160925E-2,0.31034482758620691,9.9343185550082105E-2,0.16338259441707717,0.13875205254515599,null,"% Total",{"$f":"P12/(SUM($P$4:$W$11))","v":0.10031347962382446},{"$f":"Q12/(SUM($P$4:$W$11))","v":4.2319749216300946E-2},0.15099268547544409,0.11389759665621735,4.7021943573667707E-2,0.46656217345872525,7.5235109717868343E-2,3.6572622779519328E-3]
[null,"Cocoa Butter"]
[null,"Coconut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%"]
[null,"Cottonseed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Evening Primrose",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA5/AB5","v":0.72222222222222221}]
[null,"Flaxseed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.62045454545454559]
[null,"Goose Fat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.82173913043478264]
[null,"Grapeseed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3945652173913044]
[null,"Hazelnut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.62187500000000007]
[null,"Hemp Seed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.50700000000000001]
[null,"Jojoba (Wax)"]
[null,"Lanolin"]
[null,"Lard"]
[null,"Linseed"]
[null,"Macadamia"]
[null,"Mango Butter"]
[null,"Meadowfoam"]
[null,"Mink"]
[null,"Mustard"]
[null,"Neat's foot"]
[null,"Neem"]
[null,"Not Used"]
[null,"Nutmeg Butter"]
[null,"Olive Pomace"]
[null,"Olive"]
[null,"Palm"]
[null,"Palm Kernel"]
[null,"Palm, Stearic"]
[null,"Peach Kernel"]
[null,"Peanut"]
[null,"Perilla"]
[null,"Pistachio Nut"]
[null,"Poppyseed"]
[null,"Pumpkinseed"]
[null,"Rapeseed"]
[null,"Rice Bran"]
[null,"Rose Hip Seed"]
[null,"Safflower"]
[null,"Sal Butter"]
[null,"Sesame Seed"]
[null,"Shea Butter"]
[null,"Soybean"]
[null,"Stearic Acid"]
[null,"Sunflower Seed"]
[null,"Sweet Almond"]
[null,"Tamanu"]
[null,"Walnut"]
[null,"Wheatgerm"]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I find this helpful to visualise what properties a soap will have - and to make sure I don’t do something stupid! The various tables use standard values to evaluate the likely characteristics of the finished product given the percentages of the oils that might be used. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Simply type in the name of the oils you wish to use (from the list on the right) and the percentage of each in the “Soaping Oils” table and the program will find the fatty acid breakdown and calculate the soapy character of the resulting soap."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you wish to add an oil not on the list you need to find all its fatty acid breakdown and add it to the “Oils by Fatty Acid List” sheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The tables will check that you have added 100% of oils by changing colour if there is a problem. Similarly, the “Expected Soap Characteristics” table totals will turn yellow if a value is too low and red if it is too high. This information is also available visually on the graph which will update dynamically with the green bar showing the actual result compared to the other bars showing the upper and lower desirable values."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Once you have a formula that you are happy with just copy it to the “Recipe” table to embellish it with colours and fragrances."]

{"sheet":"Print 1","index":2,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":true,"merged":[[45,1,45,2],[13,1,13,4],[25,1,25,4],[36,1,36,4],[56,1,56,2],[47,1,47,4],[48,1,48,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[48,5,56,9],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[11,2,11,4],[10,2,10,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4]]}
[]
[]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-09-27"},"Date ready",{"$f":"G3+30","v":"2023-10-27"}]
[]
[]
[null,"Container volume (ml)",{"$f":"Recipe!C6","v":1420},null,null,"Weight of Batch (g)",{"$f":"Recipe!C8","v":1388.7609600000001}]
[null,"Water:Lye Ratio",{"$f":"Recipe!C3","v":"2:1, Moderate Discount"},null,null,"Volume of Oils (ml)",{"$f":"Recipe!C9","v":1017}]
[null,"Superfat",{"$f":"Recipe!C4","v":0.04},null,null,"Weight of Water (g)",{"$f":"Recipe!C10","v":270}]
[null,"Number of Bars",{"$f":"Recipe!C7","v":9},null,null,"Weight of Lye (g)",{"$f":"Recipe!C12","v":142.76096000000001}]
[null,"Lye as % of Water",{"$f":"Recipe!C14","v":0.34586836894652057},null,null,"Weight of Oils (g)",{"$f":"Recipe!C11","v":936}]
[null,"Loaves",{"$f":"VLOOKUP(Recipe!C2,'Mould Sizes'!B4:L16,10,FALSE)","v":1},null,null,"Bar Weight",{"$f":"Recipe!C17","v":154}]
[null,"Citric Acid",{"$f":"Recipe!F12","v":"Yes"},null,null,"Cured Bar Weight",{"$f":"Recipe!C18","v":124}]
[]
[null,"Oils",null,null,null,null,"Notes"]
[null,"Type of Oil","%","Weight","Cost"]
[null,{"$f":"Recipe!E4","v":"Olive"},{"$f":"Recipe!F4","v":0.35},{"$f":"IF(B16>0,Recipe!H4,0)","v":328},{"$f":"Recipe!J4","v":1.968}]
[null,{"$f":"Recipe!E5","v":"Coconut"},{"$f":"Recipe!F5","v":0.2},{"$f":"IF(B17>0,Recipe!H5,0)","v":187},{"$f":"Recipe!J5","v":1.0846}]
[null,{"$f":"Recipe!E6","v":"Lard"},{"$f":"Recipe!F6","v":0.25},{"$f":"IF(B18>0,Recipe!H6,0)","v":234},{"$f":"Recipe!J6","v":4.6706400000000006}]
[null,{"$f":"Recipe!E7","v":"Shea Butter"},{"$f":"Recipe!F7","v":0.15},{"$f":"IF(B19>0,Recipe!H7,0)","v":140},{"$f":"Recipe!J7","v":2.66}]
[null,{"$f":"Recipe!E8","v":"Castor"},{"$f":"Recipe!F8","v":0.05},{"$f":"IF(B20>0,Recipe!H8,0)","v":47},{"$f":"Recipe!J8","v":0.42770000000000002}]
[null,{"$f":"Recipe!E9","v":0},{"$f":"Recipe!F9","v":0},{"$f":"IF(B21>0,Recipe!H9,0)","v":0},{"$f":"Recipe!J9","v":0}]
[null,{"$f":"Recipe!E10","v":0},{"$f":"Recipe!F10","v":0},{"$f":"IF(B22>0,Recipe!H10,0)","v":0},{"$f":"Recipe!J10","v":0}]
[null,{"$f":"Recipe!E11","v":0},{"$f":"Recipe!F11","v":0},{"$f":"IF(B23>0,Recipe!H11,0)","v":0},{"$f":"Recipe!J11","v":0}]
[null,"Total",{"$f":"SUM(C16:C23)","v":1},{"$f":"SUM(D16:D23)","v":936},10.81094]
[]
[null,"Fragrances"]
[null,"Name of Fragrance","%","Weight","Cost"]
[null,{"$f":"Recipe!E17","v":"Patchouli"},{"$f":"Recipe!G17","v":0},{"$f":"IF(Recipe!H17>0,Recipe!H17,Recipe!I17)","v":20},{"$f":"Recipe!J17","v":0.96}]
[null,{"$f":"Recipe!E18","v":"Lavender"},{"$f":"Recipe!G18","v":0},{"$f":"IF(Recipe!H18>0,Recipe!H18,Recipe!I18)","v":20},{"$f":"Recipe!J18","v":5.4}]
[null,{"$f":"Recipe!E19","v":0},{"$f":"Recipe!G19","v":0},{"$f":"IF(Recipe!H19>0,Recipe!H19,Recipe!I19)","v":0},{"$f":"Recipe!J19","v":0}]
[null,{"$f":"Recipe!E20","v":0},{"$f":"Recipe!G20","v":0},{"$f":"IF(Recipe!H20>0,Recipe!H20,Recipe!I20)","v":0},{"$f":"Recipe!J20","v":0}]
[null,{"$f":"Recipe!E21","v":0},{"$f":"Recipe!G21","v":0},{"$f":"IF(Recipe!H21>0,Recipe!H21,Recipe!I21)","v":0},{"$f":"Recipe!J21","v":0}]
[null,{"$f":"Recipe!E22","v":0},{"$f":"Recipe!G22","v":0},{"$f":"IF(Recipe!H22>0,Recipe!H22,Recipe!I22)","v":0},{"$f":"Recipe!J22","v":0}]
[null,{"$f":"Recipe!E23","v":0},{"$f":"Recipe!G23","v":0},{"$f":"IF(Recipe!H23>0,Recipe!H23,Recipe!I23)","v":0},{"$f":"Recipe!J23","v":0}]
[null,{"$f":"B24","v":"Total"},null,{"$f":"SUM(D28:D34)","v":40},{"$f":"SUM(E28:E34)","v":6.36}]
[]
[null,"Colours"]
[null,"Name of Colour",null,"Weight","Cost"]
[null,{"$f":"Recipe!E28","v":0},null,{"$f":"Recipe!F28","v":0},{"$f":"Recipe!G28","v":0}]
[null,{"$f":"Recipe!E29","v":0},null,{"$f":"Recipe!F29","v":0},{"$f":"Recipe!G29","v":0}]
[null,{"$f":"Recipe!E30","v":0},null,{"$f":"Recipe!F30","v":0},{"$f":"Recipe!G30","v":0}]
[null,{"$f":"Recipe!E31","v":0},null,{"$f":"Recipe!F31","v":0},{"$f":"Recipe!G31","v":0}]
[null,{"$f":"Recipe!E32","v":0},null,{"$f":"Recipe!F32","v":0},{"$f":"Recipe!G32","v":0}]
[null,{"$f":"Recipe!E33","v":0},null,{"$f":"Recipe!F33","v":0},{"$f":"Recipe!G33","v":0}]
[null,{"$f":"Recipe!E34","v":0},null,{"$f":"Recipe!F34","v":0},{"$f":"Recipe!G34","v":0}]
[null,{"$f":"B24","v":"Total"},null,{"$f":"SUM(D39:D45)","v":0},{"$f":"SUM(E39:E45)","v":0}]
[]
[null,"Additives"]
[null,"Name",null,"Amount","Cost"]
[null,{"$f":"Recipe!H28","v":0},null,{"$f":"Recipe!I28","v":0},{"$f":"Recipe!J28","v":0}]
[null,{"$f":"Recipe!H29","v":0},null,{"$f":"Recipe!I29","v":0},{"$f":"Recipe!J29","v":0}]
[null,{"$f":"Recipe!H30","v":0},null,{"$f":"Recipe!I30","v":0},{"$f":"Recipe!J30","v":0}]
[null,{"$f":"Recipe!H31","v":0},null,{"$f":"Recipe!I31","v":0},{"$f":"Recipe!J31","v":0}]
[null,{"$f":"Recipe!H32","v":0},null,{"$f":"Recipe!I32","v":0},{"$f":"Recipe!J32","v":0}]
[null,{"$f":"Recipe!H33","v":0},null,{"$f":"Recipe!I33","v":0},{"$f":"Recipe!J33","v":0}]
[null,{"$f":"Recipe!E12","v":"Citric Acid (1.5%)"},null,{"$f":"Recipe!H12","v":14.04},{"$f":"Recipe!J12","v":0.32682}]
[null,{"$f":"B24","v":"Total"},null,{"$f":"SUM(D50:D56)","v":14.04},{"$f":"SUM(E50:E56)","v":0.32682}]
[]
[null,"Cost per Bar",{"$f":"C61/C9","v":1.9441955555555555}]
[]
[null,"Cost of Batch",{"$f":"SUM(E57+E46+E35+E24)","v":17.49776}]

{"sheet":"Recipe","index":3,"n_rows":36,"n_cols":21,"rows_kept":36,"cut":false,"hidden":false,"merged":[[25,7,25,9],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[25,4,25,6],[18,4,18,5],[1,4,1,9],[14,4,14,9],[15,4,15,5],[16,4,16,5],[17,4,17,5]]}
[]
[null,"Mould Used","Small Silicone Loaf",null,"Oils"]
[null,"Water:Lye Ratio","2:1, Moderate Discount",null,"Name of Oil","%","Manual Oil Weights","Auto Oil Weights","Weight of Lye (NaOH)","Cost"]
[null,"Superfat",0.04,null,"Olive",0.35,null,{"$f":"IF(E4>0,IFERROR(IF($G$13>0,\"<= Use Manual Input\",'Calculations 2'!J10),0),0)","v":328},{"$f":"'Calculations 2'!K10","v":44},{"$f":"IFERROR(VLOOKUP(E4,Oils!A:G,7,FALSE)*'Calculations 2'!J10,0)","v":1.968}]
[null,"Mould Max Volume (ml)",{"$f":"IFERROR(VLOOKUP(C2,'Mould Sizes'!B:L,5,FALSE),0)","v":1456},null,"Coconut",0.2,null,{"$f":"IF(E5>0,IFERROR(IF($G$13>0,\"<= Use Manual Input\",'Calculations 2'!J11),0),0)","v":187},{"$f":"'Calculations 2'!K11","v":34},{"$f":"IFERROR(VLOOKUP(E5,Oils!A:G,7,FALSE)*'Calculations 2'!J11,0)","v":1.0846}]
[null,"Actual Volume Used in Mould",{"$f":"IFERROR(VLOOKUP(C2,'Mould Sizes'!B3:M33,11,FALSE),0)","v":1420},null,"Lard",0.25,null,{"$f":"IF(E6>0,IFERROR(IF($G$13>0,\"<= Use Manual Input\",'Calculations 2'!J12),0),0)","v":234},{"$f":"'Calculations 2'!K12","v":32},{"$f":"IFERROR(VLOOKUP(E6,Oils!A:G,7,FALSE)*'Calculations 2'!J12,0)","v":4.6706400000000006}]
[null,"Number of Bars",{"$f":"IFERROR(VLOOKUP(C2,'Mould Sizes'!B4:M21,12,FALSE),0)","v":9},null,"Shea Butter",0.15,null,{"$f":"IF(E7>0,IFERROR(IF($G$13>0,\"<= Use Manual Input\",'Calculations 2'!J13),0),0)","v":140},{"$f":"'Calculations 2'!K13","v":18},{"$f":"IFERROR(VLOOKUP(E7,Oils!A:G,7,FALSE)*'Calculations 2'!J13,0)","v":2.66}]
[null,"Weight of Batch",{"$f":"IFERROR(C11+C10+I13+I24+F35+I35,0)","v":1388.7609600000001},null,"Castor",0.05,null,{"$f":"IF(E8>0,IFERROR(IF($G$13>0,\"<= Use Manual Input\",'Calculations 2'!J14),0),0)","v":47},{"$f":"'Calculations 2'!K14","v":6},{"$f":"IFERROR(VLOOKUP(E8,Oils!A:G,7,FALSE)*'Calculations 2'!J14,0)","v":0.42770000000000002}]
[null,"Volume of Oils (ml)",{"$f":"IFERROR('Calculations 2'!I18,0)","v":1017},null,null,null,null,{"$f":"IF(E9>0,IFERROR(IF($G$13>0,\"<= Use Manual Input\",'Calculations 2'!J15),0),0)","v":0},{"$f":"'Calculations 2'!K15","v":0},{"$f":"IFERROR(VLOOKUP(E9,Oils!A:G,7,FALSE)*'Calculations 2'!J15,0)","v":0}]
[null,"Volume/Weight of Water (g)",{"$f":"IFERROR('Calculations 2'!L18,0)","v":270},null,null,null,null,{"$f":"IF(E10>0,IFERROR(IF($G$13>0,\"<= Use Manual Input\",'Calculations 2'!J16),0),0)","v":0},{"$f":"'Calculations 2'!K16","v":0},{"$f":"IFERROR(VLOOKUP(E10,Oils!A:G,7,FALSE)*'Calculations 2'!J16,0)","v":0}]
[null,"Weight of Oils",{"$f":"IFERROR('Calculations 2'!J18,0)","v":936},null,null,null,null,{"$f":"IF(E11>0,IFERROR(IF($G$13>0,\"<= Use Manual Input\",'Calculations 2'!J17),0),0)","v":0},{"$f":"'Calculations 2'!K17","v":0},{"$f":"IFERROR(VLOOKUP(E11,Oils!A:G,7,FALSE)*'Calculations 2'!J17,0)","v":0}]
[null,"Adjusted Lye Weight",{"$f":"I13","v":142.76096000000001},null,"Citric Acid (1.5%)","Yes",null,{"$f":"IF(F12=\"Yes\",IF(H13>0,(0.015*H13),0.015*G13),0)","v":14.04},{"$f":"H12*0.624","v":8.760959999999999},{"$f":"IFERROR(VLOOKUP(E12,Oils!A:G,7,FALSE)*H12,0)","v":0.32682}]
[null,"Water as a % of Oils",{"$f":"IFERROR(C10/C11,0)","v":0.28846153846153844},null,"Totals",{"$f":"SUM(F4:F12)","v":1},{"$f":"SUM(G4:G12)","v":0},{"$f":"SUM(H4:H11)","v":936},{"$f":"SUM(I4:I12)","v":142.76096000000001},{"$f":"SUM(J4:J12)","v":11.13776}]
[null,"Lye as % of Water",{"$f":"IFERROR(C12/(C10+C12),0)","v":0.34586836894652057}]
[null,"Cost of Batch",{"$f":"(J13+J24+G35+J35)","v":17.49776},null,"Fragrances"]
[null,"Cost per Bar",{"$f":"IFERROR((C15/C7),0)","v":1.9441955555555555},null,"Name of Fragrance",null,"%","Manual Weight","Auto Weight","Cost"]
[null,"Cut Weight of Bar (g)",{"$f":"IFERROR(ROUNDDOWN(C8/C7,0),0)","v":154},null,"Patchouli",null,null,20,{"$f":"IFERROR(IF(H17>0,H17,G17*(C$11)),0)","v":20},{"$f":"IF(E17<>0,VLOOKUP(E17,Fragrance!A:G,7,FALSE)*Recipe!I17,0)","v":0.96}]
[null,"Cured Weight of Bars (g)",{"$f":"IFERROR(ROUNDDOWN((C8-C10)/C7,0),0)","v":124},null,"Lavender",null,null,20,20,{"$f":"IF(E18<>0,VLOOKUP(E18,Fragrance!A:G,7,FALSE)*Recipe!I18,0)","v":5.4},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((C$9*F12)*T18,0)","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(E19<>0,VLOOKUP(E19,Fragrance!A:G,7,FALSE)*Recipe!I19,0)","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(E20<>0,VLOOKUP(E20,Fragrance!A:G,7,FALSE)*Recipe!I20,0)","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(E21<>0,VLOOKUP(E21,Fragrance!A:G,7,FALSE)*Recipe!I21,0)","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(E22<>0,VLOOKUP(E22,Fragrance!A:G,7,FALSE)*Recipe!I22,0)","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(E23<>0,VLOOKUP(E23,Fragrance!A:G,7,FALSE)*Recipe!I23,0)","v":0}]
[null,null,null,null,"Totals",null,{"$f":"SUM(G16:G23)","v":0},null,{"$f":"SUM(I16:I23)","v":40},{"$f":"SUM(J17:J23)","v":6.36}]
[]
[null,null,null,null,"Colours",null,null,"Additives"]
[null,null,null,null,"Name of Colour","Amount","Cost","Name","Amount","Cost"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E28,Colourants!A:G,7,FALSE)*F28,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E29,Colourants!A:G,7,FALSE)*F29,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E30,Colourants!A:G,7,FALSE)*F30,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E31,Colourants!A:G,7,FALSE)*F31,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E32,Colourants!A:G,7,FALSE)*F32,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E33,Colourants!A:G,7,FALSE)*F33,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E34,Colourants!A:G,7,FALSE)*F34,0)","v":0}]
[null,null,null,null,"Totals",{"$f":"SUM(F27:F34)","v":0},{"$f":"SUM(G28:G34)","v":0},"Totals",{"$f":"SUM(I28:I34)","v":0},{"$f":"SUM(J28:J34)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(G35+J35)","v":0}]

{"sheet":"Standard Recipe Sheet","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Oil Name","% Used"]
["Olive",0.35]
["Coconut",0.2]
["Lard",0.25]
["Shea Butter",0.15]
["Castor",0.05]
[]
[]
[]
["Mould Used","Milk Carton"]
["Water:Lye Ratio","2:1, Moderate Discount"]
["Superfat",0.04]

{"sheet":"Mould Sizes","index":5,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":true,"merged":[[17,1,17,12],[1,1,1,12]]}
[]
[null,"RECTANGULAR MOULDS"]
[null,"Mould Name","Length (mm)","Width (mm)","Height (mm)","Max Volume (cubic mm)","Bar Thickness (mm)","Bar Width (mm)","Bar Height (mm)","Bar Volume (ml)","No. of Loaves","Used Volume (ml)","Number of Bars"]
[null,"Milk Carton",295,70,70,{"$f":"ROUND(IF('Mould Sizes'!$E4<>0,C4*D4*E4/1000,),0)","v":1446},29,70,70,{"$f":"ROUND(G4*H4*I4/1000,0)","v":142},{"$f":"IFERROR(ROUNDDOWN('Mould Sizes'!$D4/'Mould Sizes'!$H4,0),0)","v":1},{"$f":"ROUND('Mould Sizes'!$K4*'Mould Sizes'!$C4*'Mould Sizes'!$H4*'Mould Sizes'!$I4/1000,0)","v":1446},{"$f":"ROUNDDOWN(Table5[[#This Row],[Length (mm)]]/Table5[[#This Row],[Bar Thickness (mm)]]*K4,0)","v":10}]
[null,"Small Silicone Loaf",260,70,80,{"$f":"ROUND(IF('Mould Sizes'!$E5<>0,C5*D5*E5/1000,),0)","v":1456},28,70,78,153,{"$f":"IFERROR(ROUNDDOWN('Mould Sizes'!$D5/'Mould Sizes'!$H5,0),0)","v":1},{"$f":"ROUND('Mould Sizes'!$K5*'Mould Sizes'!$C5*'Mould Sizes'!$H5*'Mould Sizes'!$I5/1000,0)","v":1420},{"$f":"ROUNDDOWN(Table5[[#This Row],[Length (mm)]]/Table5[[#This Row],[Bar Thickness (mm)]]*K5,0)","v":9}]
[null,"Double Silicone Loaf",260,140,80,{"$f":"ROUND(IF('Mould Sizes'!$E6<>0,C6*D6*E6/1000,),0)","v":2912},28,70,79,155,{"$f":"IFERROR(ROUNDDOWN('Mould Sizes'!$D6/'Mould Sizes'!$H6,0),0)","v":2},{"$f":"ROUND('Mould Sizes'!$K6*'Mould Sizes'!$C6*'Mould Sizes'!$H6*'Mould Sizes'!$I6/1000,0)","v":2876},{"$f":"ROUNDDOWN(Table5[[#This Row],[Length (mm)]]/Table5[[#This Row],[Bar Thickness (mm)]]*K6,0)","v":18}]
[null,"Small Square",230,280,90,{"$f":"ROUND(IF('Mould Sizes'!$E7<>0,C7*D7*E7/1000,),0)","v":5796},25,70,89,156,{"$f":"IFERROR(ROUNDDOWN('Mould Sizes'!$D7/'Mould Sizes'!$H7,0),0)","v":4},{"$f":"ROUND('Mould Sizes'!$K7*'Mould Sizes'!$C7*'Mould Sizes'!$H7*'Mould Sizes'!$I7/1000,0)","v":5732},{"$f":"ROUNDDOWN(Table5[[#This Row],[Length (mm)]]/Table5[[#This Row],[Bar Thickness (mm)]]*K7,0)","v":36}]
[null,"Large Mould",465,480,85,{"$f":"ROUND(IF('Mould Sizes'!$E8<>0,C8*D8*E8/1000,),0)","v":18972},25,70,80,140,{"$f":"IFERROR(ROUNDDOWN('Mould Sizes'!$D8/'Mould Sizes'!$H8,0),0)","v":6},{"$f":"ROUND('Mould Sizes'!$K8*'Mould Sizes'!$C8*'Mould Sizes'!$H8*'Mould Sizes'!$I8/1000,0)","v":15624},{"$f":"ROUNDDOWN(Table5[[#This Row],[Length (mm)]]/Table5[[#This Row],[Bar Thickness (mm)]]*K8,0)","v":111}]
[null,"Commercial",800,600,80,{"$f":"ROUND(IF('Mould Sizes'!$E9<>0,C9*D9*E9/1000,),0)","v":38400},25,70,79,138,{"$f":"IFERROR(ROUNDDOWN('Mould Sizes'!$D9/'Mould Sizes'!$H9,0),0)","v":8},{"$f":"ROUND('Mould Sizes'!$K9*'Mould Sizes'!$C9*'Mould Sizes'!$H9*'Mould Sizes'!$I9/1000,0)","v":35392},{"$f":"ROUNDDOWN(Table5[[#This Row],[Length (mm)]]/Table5[[#This Row],[Bar Thickness (mm)]]*K9,0)","v":256}]
[]
[]
[]
[]
[]
[null,"Scroll down for cylinders"]
[]
[]
[null,"CIRCULAR (PIPE) MOULDS"]
[null,"Mould Name","Length (mm)","Radius (mm)","Height (N/A)","Max Volume (cubic mm)","Bar Thickness (mm)","Bar Width (N/A)","Waste (mm)","Bar Volume","Loaves","Used Volume","Number of Bars"]
[null,"Short Pipe Guest",300,55,null,{"$f":"ROUND($C20*(PI()*POWER(D20,2)/1000),0)","v":2851},20,null,4,{"$f":"ROUND($G20*(PI()*POWER(D20,2)/1000),0)","v":190},{"$f":"1","v":1},{"$f":"ROUND((Table6[[#This Row],[Length (mm)]]-Table6[[#This Row],[Bar Width (N/A)]])*(PI()*POWER(D20,2)/1000),0)","v":2851},{"$f":"IFERROR(ROUND(C20/G20,0),0)","v":15}]
[null,"Long Pipe",600,65,null,{"$f":"ROUND($C21*(PI()*POWER(D21,2)/1000),0)","v":7964},20,null,4,{"$f":"ROUND($G21*(PI()*POWER(D21,2)/1000),0)","v":265},{"$f":"1","v":1},{"$f":"ROUND((Table6[[#This Row],[Length (mm)]]-Table6[[#This Row],[Bar Width (N/A)]])*(PI()*POWER(D21,2)/1000),0)","v":7964},{"$f":"IFERROR(ROUND(C21/G21,0),0)","v":30}]

{"sheet":"Calculations 2","index":6,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Sample Batch Weight (g)",500]
[null,"Volume used in Mould",{"$f":"VLOOKUP(Recipe!C2,'Mould Sizes'!B4:M34,11,FALSE)","v":1420}]
[null,"Volume of Batch",{"$f":"F18+G18+H18","v":758.63212072373904}]
[null,"Ratio Batch to Mould",{"$f":"C3/C4","v":1.8717899772623818}]
[null,"Weight of Batch",{"$f":"J18+K18+L18","v":1340}]
[]
[]
[null,"Oil Name","%","SG","Weight of Oil","Oil Volume","Auto Lye","Auto Water","Scaled Oil Volume","Scaled Oil Weight","Scaled Lye Weight","Scaled Water Weight"]
[null,{"$f":"Recipe!E4","v":"Olive"},{"$f":"IFERROR(IF(B10<>\"\",VLOOKUP(B10,Recipe!$E4:$F4,2),0),0)","v":0.35},{"$f":"IFERROR(IF(ISBLANK(Recipe!E4),0,VLOOKUP(B10,Oils!A:D,4)),0)","v":0.91800000000000004},{"$f":"IF('Calculations 2'!$B10<>0,'Calculations 2'!$C10*$C$2,0)","v":175},{"$f":"IFERROR(E10/D10,0)","v":190.63180827886708},{"$f":"IF('Calculations 2'!$C10<>0,VLOOKUP(B10,Oils!A:B,2)*'Calculations 2'!E10,0)","v":23.450000000000003},{"$f":"VLOOKUP(Recipe!$C$3,'Calculations 2'!$B$23:$E$27,4,FALSE)*G10","v":46.900000000000006},{"$f":"ROUND('Calculations 2'!$F10*$C$5,0)","v":357},{"$f":"ROUND(IF('Calculations 2'!$B10<>0,'Calculations 2'!$E10*$C$5,0),0)","v":328},{"$f":"ROUND(IF('Calculations 2'!$B10<>0,'Calculations 2'!$G10*$C$5,0),0)","v":44},{"$f":"ROUND('Calculations 2'!$H10*$C$5,0)","v":88}]
[null,{"$f":"Recipe!E5","v":"Coconut"},{"$f":"IFERROR(IF(B11<>\"\",VLOOKUP(B11,Recipe!$E5:$F5,2),0),0)","v":0.2},{"$f":"IFERROR(IF(ISBLANK(Recipe!E5),0,VLOOKUP(B11,Oils!A:D,4)),0)","v":0.92400000000000004},{"$f":"IF('Calculations 2'!$B11<>0,'Calculations 2'!$C11*$C$2,0)","v":100},108.22510822510822,{"$f":"IF('Calculations 2'!$C11<>0,VLOOKUP(B11,Oils!A:B,2)*'Calculations 2'!E11,0)","v":18.3},{"$f":"VLOOKUP(Recipe!$C$3,'Calculations 2'!$B$23:$E$27,4,FALSE)*G11","v":36.6},{"$f":"ROUND('Calculations 2'!$F11*$C$5,0)","v":203},{"$f":"ROUND(IF('Calculations 2'!$B11<>0,'Calculations 2'!$E11*$C$5,0),0)","v":187},{"$f":"ROUND(IF('Calculations 2'!$B11<>0,'Calculations 2'!$G11*$C$5,0),0)","v":34},{"$f":"ROUND('Calculations 2'!$H11*$C$5,0)","v":69}]
[null,{"$f":"Recipe!E6","v":"Lard"},{"$f":"IFERROR(IF(B12<>\"\",VLOOKUP(B12,Recipe!$E6:$F6,2),0),0)","v":0.25},{"$f":"IFERROR(IF(ISBLANK(Recipe!E6),0,VLOOKUP(B12,Oils!A:D,4)),0)","v":0.92500000000000004},{"$f":"IF('Calculations 2'!$B12<>0,'Calculations 2'!$C12*$C$2,0)","v":125},135.13513513513513,{"$f":"IF('Calculations 2'!$C12<>0,VLOOKUP(B12,Oils!A:B,2)*'Calculations 2'!E12,0)","v":17.25},{"$f":"VLOOKUP(Recipe!$C$3,'Calculations 2'!$B$23:$E$27,4,FALSE)*G12","v":34.5},{"$f":"ROUND('Calculations 2'!$F12*$C$5,0)","v":253},{"$f":"ROUND(IF('Calculations 2'!$B12<>0,'Calculations 2'!$E12*$C$5,0),0)","v":234},{"$f":"ROUND(IF('Calculations 2'!$B12<>0,'Calculations 2'!$G12*$C$5,0),0)","v":32},{"$f":"ROUND('Calculations 2'!$H12*$C$5,0)","v":65}]
[null,{"$f":"Recipe!E7","v":"Shea Butter"},{"$f":"IFERROR(IF(B13<>\"\",VLOOKUP(B13,Recipe!$E7:$F7,2),0),0)","v":0.15},{"$f":"IFERROR(IF(ISBLANK(Recipe!E7),0,VLOOKUP(B13,Oils!A:D,4)),0)","v":0.9},{"$f":"IF('Calculations 2'!$B13<>0,'Calculations 2'!$C13*$C$2,0)","v":75},83.333333333333329,{"$f":"IF('Calculations 2'!$C13<>0,VLOOKUP(B13,Oils!A:B,2)*'Calculations 2'!E13,0)","v":9.6},{"$f":"VLOOKUP(Recipe!$C$3,'Calculations 2'!$B$23:$E$27,4,FALSE)*G13","v":19.2},{"$f":"ROUND('Calculations 2'!$F13*$C$5,0)","v":156},{"$f":"ROUND(IF('Calculations 2'!$B13<>0,'Calculations 2'!$E13*$C$5,0),0)","v":140},{"$f":"ROUND(IF('Calculations 2'!$B13<>0,'Calculations 2'!$G13*$C$5,0),0)","v":18},{"$f":"ROUND('Calculations 2'!$H13*$C$5,0)","v":36}]
[null,{"$f":"Recipe!E8","v":"Castor"},{"$f":"IFERROR(IF(B14<>\"\",VLOOKUP(B14,Recipe!$E8:$F8,2),0),0)","v":0.05},{"$f":"IFERROR(IF(ISBLANK(Recipe!E8),0,VLOOKUP(B14,Oils!A:D,4)),0)","v":0.96499999999999997},{"$f":"IF('Calculations 2'!$B14<>0,'Calculations 2'!$C14*$C$2,0)","v":25},25.906735751295336,{"$f":"IF('Calculations 2'!$C14<>0,VLOOKUP(B14,Oils!A:B,2)*'Calculations 2'!E14,0)","v":3.2},{"$f":"VLOOKUP(Recipe!$C$3,'Calculations 2'!$B$23:$E$27,4,FALSE)*G14","v":6.4},{"$f":"ROUND('Calculations 2'!$F14*$C$5,0)","v":48},{"$f":"ROUND(IF('Calculations 2'!$B14<>0,'Calculations 2'!$E14*$C$5,0),0)","v":47},{"$f":"ROUND(IF('Calculations 2'!$B14<>0,'Calculations 2'!$G14*$C$5,0),0)","v":6},{"$f":"ROUND('Calculations 2'!$H14*$C$5,0)","v":12}]
[null,{"$f":"Recipe!E9","v":0},{"$f":"IFERROR(IF(B15<>\"\",VLOOKUP(B15,Recipe!$E9:$F9,2),0),0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Recipe!E9),0,VLOOKUP(B15,Oils!A:D,4)),0)","v":0},{"$f":"IF('Calculations 2'!$B15<>0,'Calculations 2'!$C15*$C$2,0)","v":0},0,{"$f":"IF('Calculations 2'!$C15<>0,VLOOKUP(B15,Oils!A:B,2)*'Calculations 2'!E15,0)","v":0},{"$f":"VLOOKUP(Recipe!$C$3,'Calculations 2'!$B$23:$E$27,4,FALSE)*G15","v":0},{"$f":"ROUND('Calculations 2'!$F15*$C$5,0)","v":0},{"$f":"ROUND(IF('Calculations 2'!$B15<>0,'Calculations 2'!$E15*$C$5,0),0)","v":0},{"$f":"ROUND(IF('Calculations 2'!$B15<>0,'Calculations 2'!$G15*$C$5,0),0)","v":0},{"$f":"ROUND('Calculations 2'!$H15*$C$5,0)","v":0}]
[null,{"$f":"Recipe!E10","v":0},{"$f":"IFERROR(IF(B16<>\"\",VLOOKUP(B16,Recipe!$E10:$F10,2),0),0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Recipe!E10),0,VLOOKUP(B16,Oils!A:D,4)),0)","v":0},{"$f":"IF('Calculations 2'!$B16<>0,'Calculations 2'!$C16*$C$2,0)","v":0},0,{"$f":"IF('Calculations 2'!$C16<>0,VLOOKUP(B16,Oils!A:B,2)*'Calculations 2'!E16,0)","v":0},{"$f":"VLOOKUP(Recipe!$C$3,'Calculations 2'!$B$23:$E$27,4,FALSE)*G16","v":0},{"$f":"ROUND('Calculations 2'!$F16*$C$5,0)","v":0},{"$f":"ROUND(IF('Calculations 2'!$B16<>0,'Calculations 2'!$E16*$C$5,0),0)","v":0},{"$f":"ROUND(IF('Calculations 2'!$B16<>0,'Calculations 2'!$G16*$C$5,0),0)","v":0},{"$f":"ROUND('Calculations 2'!$H16*$C$5,0)","v":0}]
[null,{"$f":"Recipe!E11","v":0},{"$f":"IFERROR(IF(B17<>\"\",VLOOKUP(B17,Recipe!$E11:$F11,2),0),0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Recipe!E11),0,VLOOKUP(B17,Oils!A:D,4)),0)","v":0},{"$f":"IF('Calculations 2'!$B17<>0,'Calculations 2'!$C17*$C$2,0)","v":0},0,{"$f":"IF('Calculations 2'!$C17<>0,VLOOKUP(B17,Oils!A:B,2)*'Calculations 2'!E17,0)","v":0},{"$f":"VLOOKUP(Recipe!$C$3,'Calculations 2'!$B$23:$E$27,4,FALSE)*G17","v":0},{"$f":"ROUND('Calculations 2'!$F17*$C$5,0)","v":0},{"$f":"ROUND(IF('Calculations 2'!$B17<>0,'Calculations 2'!$E17*$C$5,0),0)","v":0},{"$f":"ROUND(IF('Calculations 2'!$B17<>0,'Calculations 2'!$G17*$C$5,0),0)","v":0},{"$f":"ROUND('Calculations 2'!$H17*$C$5,0)","v":0}]
[null,null,{"$f":"IF('Calculations 2'!$B18<>0,VLOOKUP('Calculations 2'!$B18,Recipe!$E$4:$F$11,2),0)","v":0},"Totals",{"$f":"SUM(E10:E17)","v":500},{"$f":"SUM(F10:F17)","v":543.23212072373906},{"$f":"SUM(G10:G17)","v":71.8},{"$f":"SUM(H10:H17)","v":143.6},{"$f":"ROUND('Calculations 2'!$F18*$C$5,0)","v":1017},{"$f":"SUM(J10:J17)","v":936},{"$f":"ROUND(SUM(K10:K17),0)","v":134},{"$f":"ROUND(SUM(L10:L17),0)","v":270}]
[]
[]
[]
[null,"Column3","Water","Lye","Ratio","Column1","Column2","Column3"]
[null,"3:1, Full Water",75,{"$f":"100-C23","v":25},{"$f":"ROUNDDOWN(C23/D23,1)","v":3},1,{"$f":"CONCATENATE(Table4812[[#This Row],[Ratio]],\":\",Table4812[[#This Row],[Column1]])","v":"3:1"}]
[null,"2.5:1, Light Discount",72,{"$f":"100-C24","v":28},{"$f":"ROUNDDOWN(C24/D24,1)","v":2.5},1,{"$f":"CONCATENATE(Table4812[[#This Row],[Ratio]],\":\",Table4812[[#This Row],[Column1]])","v":"2.5:1"}]
[null,"2:1, Moderate Discount",67,{"$f":"100-C25","v":33},{"$f":"ROUNDDOWN(C25/D25,1)","v":2},1,{"$f":"CONCATENATE(Table4812[[#This Row],[Ratio]],\":\",Table4812[[#This Row],[Column1]])","v":"2:1"}]
[null,"1.5:1, Heavy Discount",60,{"$f":"100-C26","v":40},{"$f":"ROUNDDOWN(C26/D26,1)","v":1.5},1,{"$f":"CONCATENATE(Table4812[[#This Row],[Ratio]],\":\",Table4812[[#This Row],[Column1]])","v":"1.5:1"}]
[null,"1:1, Very Heavy Discount",50,{"$f":"100-C27","v":50},{"$f":"ROUNDDOWN(C27/D27,1)","v":1},1,{"$f":"CONCATENATE(Table4812[[#This Row],[Ratio]],\":\",Table4812[[#This Row],[Column1]])","v":"1:1"}]

{"sheet":"Batches","index":7,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,1,0,11]]}
[null,"Batches"]
[null,"Made","No. of Bars","Fragrance","Batch OILS cost","FRAGRANCE COST","Sundries","Cost per bar","Markup","SELL Price","PROFIT","Date Ready"]
[null,"2023-06-13",11,"Blackberry Sage",9.34,7.5,null,{"$f":"IFERROR((E3+Table10[[#This Row],[FRAGRANCE COST]])/C3,0)","v":1.530909090909091},4,{"$f":"IFERROR(ROUNDUP((H3*I3),0),0)","v":7},{"$f":"(Table10[[#This Row],[SELL Price]]-Table10[[#This Row],[Cost per bar]])*Table10[[#This Row],[No. of Bars]]","v":60.16},{"$f":"IF(Table10[[#This Row],[Made]]>0,Table10[[#This Row],[Made]]+28,0)","v":"2023-07-11"}]
[null,"2023-08-05",14,"Mango",16.2425,3.5000000000000004,null,{"$f":"IFERROR((E4+Table10[[#This Row],[FRAGRANCE COST]])/C4,0)","v":1.4101785714285715},4,6,{"$f":"(Table10[[#This Row],[SELL Price]]-Table10[[#This Row],[Cost per bar]])*Table10[[#This Row],[No. of Bars]]","v":64.257500000000007},{"$f":"IF(Table10[[#This Row],[Made]]>0,Table10[[#This Row],[Made]]+28,0)","v":"2023-09-02"}]
[null,"2023-08-24",20,"Coconut",11.741300000000001,5.2347428571428578,0.92999999999999994,0.89530214285714282,3,3,{"$f":"(Table10[[#This Row],[SELL Price]]-Table10[[#This Row],[Cost per bar]])*Table10[[#This Row],[No. of Bars]]","v":42.093957142857136},{"$f":"IF(Table10[[#This Row],[Made]]>0,Table10[[#This Row],[Made]]+28,0)","v":"2023-09-21"}]
[null,"2023-08-24",10,"Christmas Kitchen",2.5067999999999997,3.2810000000000001,0.46499999999999997,0.62527999999999995,4,3,{"$f":"(Table10[[#This Row],[SELL Price]]-Table10[[#This Row],[Cost per bar]])*Table10[[#This Row],[No. of Bars]]","v":23.747199999999999},{"$f":"IF(Table10[[#This Row],[Made]]>0,Table10[[#This Row],[Made]]+28,0)","v":"2023-09-21"}]
[null,"2023-08-24",10,"Cedarwood",7.7423999999999991,3.1488,0.75,1.16412,4,5,{"$f":"(Table10[[#This Row],[SELL Price]]-Table10[[#This Row],[Cost per bar]])*Table10[[#This Row],[No. of Bars]]","v":38.358800000000002},{"$f":"IF(Table10[[#This Row],[Made]]>0,Table10[[#This Row],[Made]]+28,0)","v":"2023-09-21"}]
[null,"2023-09-26",9,"Christmas Kitchen",7.8459233333333334,3.1688000000000005,0.46639999999999998,1.2756803703703705,4,{"$f":"IFERROR(ROUNDUP((H8*I8),0),0)","v":6},{"$f":"(Table10[[#This Row],[SELL Price]]-Table10[[#This Row],[Cost per bar]])*Table10[[#This Row],[No. of Bars]]","v":42.518876666666671},{"$f":"IF(Table10[[#This Row],[Made]]>0,Table10[[#This Row],[Made]]+28,0)","v":"2023-10-24"}]
[null,"2023-09-27",9,"Patchouli EO",11.13776,0.96,0.64639999999999997,1.4160177777777778,4,{"$f":"IFERROR(ROUNDUP((H9*I9),0),0)","v":6},{"$f":"(Table10[[#This Row],[SELL Price]]-Table10[[#This Row],[Cost per bar]])*Table10[[#This Row],[No. of Bars]]","v":41.255839999999992},{"$f":"IF(Table10[[#This Row],[Made]]>0,Table10[[#This Row],[Made]]+28,0)","v":"2023-10-25"}]
[null,"2023-09-27",9,"Patchouli & Lavender EO",11.13776,6.36,0,1.9441955555555555,4,{"$f":"IFERROR(ROUNDUP((H10*I10),0),0)","v":8},{"$f":"(Table10[[#This Row],[SELL Price]]-Table10[[#This Row],[Cost per bar]])*Table10[[#This Row],[No. of Bars]]","v":54.50224},{"$f":"IF(Table10[[#This Row],[Made]]>0,Table10[[#This Row],[Made]]+28,0)","v":"2023-10-25"}]

{"sheet":"Fragrance","index":8,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Fragrance Name","Type","Brand","Supplier","Package Size (ml)","Package Cost","Cost / unit","Rec. %"]
["Black Raspberry & Vanilla","Fragrance Oil","Luxaroma","Eroma",520,27.05,{"$f":"IF(E2>0,F2/E2,0)","v":5.2019230769230769E-2},0.05]
["Blackberry Sage","Fragrance Oil","Bramble Berry","Aussie Soap Supplies",100,18.75,{"$f":"IF(E3>0,F3/E3,0)","v":0.1875},0.05]
["Cedarwood","Essential Oil","Escentials ","Escentials ",500,41,{"$f":"IF(E4>0,F4/E4,0)","v":8.2000000000000003E-2},0.05]
["Christmas Cedar","Fragrance Oil","Luxaroma","Eroma",520,29.53,{"$f":"IF(E5>0,F5/E5,0)","v":5.6788461538461538E-2},0.05]
["Christmas Kitchen","Fragrance Oil","Escentials ","Escentials ",100,8.5,{"$f":"IF(E6>0,F6/E6,0)","v":8.5000000000000006E-2},0.05]
["Clary Sage","Essential Oil","Escentials ","Escentials ",100,35,{"$f":"IF(E7>0,F7/E7,0)","v":0.35},0.05]
["Coconut","Fragrance Oil","Luxaroma","Eroma",105,7.92,{"$f":"IF(E8>0,F8/E8,0)","v":7.5428571428571428E-2},0.05]
["Coffee (USA)","Fragrance Oil","Escentials ","Escentials ",100,8.5,{"$f":"IF(E9>0,F9/E9,0)","v":8.5000000000000006E-2},0.05]
["Country Kitchen","Fragrance Oil","Bramble Berry","Aussie Soap Supplies",100,16,{"$f":"IF(E10>0,F10/E10,0)","v":0.16},0.05]
["Eucalyptus","Essential Oil","Aldi","Aldi",100,6.5,{"$f":"IF(E11>0,F11/E11,0)","v":6.5000000000000002E-2},0.05]
["Frangipani","Fragrance Oil","Escentials ","Escentials ",100,8.5,{"$f":"IF(E12>0,F12/E12,0)","v":8.5000000000000006E-2},0.05]
["Ginger Ale","Fragrance Oil","Bramble Berry","Aussie Soap Supplies",100,16.5,{"$f":"IF(E13>0,F13/E13,0)","v":0.16500000000000001},0.05]
["Green Apple (USA)","Fragrance Oil","Escentials ","Escentials ",100,8.5,{"$f":"IF(E14>0,F14/E14,0)","v":8.5000000000000006E-2},0.05]
["Honey almond","Fragrance Oil","Escentials ","Escentials ",100,8.5,{"$f":"IF(E15>0,F15/E15,0)","v":8.5000000000000006E-2},0.05]
["Lavender","Essential Oil","Ahimsa","Ahimsa",100,27,{"$f":"IF(E16>0,F16/E16,0)","v":0.27},0.04]
["Lemongrass Cochin","Essential Oil","Escentials ","Escentials ",100,8.5,{"$f":"IF(E17>0,F17/E17,0)","v":8.5000000000000006E-2},0.05]
["Mango","Fragrance Oil","Escentials ","Escentials ",100,7,{"$f":"IF(E18>0,F18/E18,0)","v":7.0000000000000007E-2},0.05]
["Patchouli","Essential Oil","New Directions","New Directions",500,24,{"$f":"IF(E19>0,F19/E19,0)","v":4.8000000000000001E-2},0.04]
["Raspberry Cream USA","Fragrance Oil","Escentials ","Escentials ",100,7,{"$f":"IF(E20>0,F20/E20,0)","v":7.0000000000000007E-2},0.05]
["Relaxation Blend","Essential Oil","New Directions","New Directions",100,32,{"$f":"IF(E21>0,F21/E21,0)","v":0.32},0.05]
["Sandalwood (Mysore)","Essential Oil","Escentials ","Escentials ",100,9.8000000000000007,{"$f":"IF(E22>0,F22/E22,0)","v":9.8000000000000004E-2},0.05]
["Sandalwood/Coconut","Fragrance Oil","Luxaroma","Eroma",105,8.73,{"$f":"IF(E23>0,F23/E23,0)","v":8.3142857142857143E-2},0.05]
["Sweet Orange","Essential Oil","Escentials ","Escentials ",1000,36,{"$f":"IF(E24>0,F24/E24,0)","v":3.5999999999999997E-2},0.05]
["Tea Tree","Essential Oil","Aldi","Aldi",100,6.5,{"$f":"IF(E25>0,F25/E25,0)","v":6.5000000000000002E-2},0.05]

{"sheet":"Oils","index":9,"n_rows":100,"n_cols":7,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
["Fat/Oil","Sodium Hydroxide","Potassium Hydroxide","Specific","Package Price","Package Size","Cost / g"]
[null,"NaOH","KOH"," Gravity",null,"g or ml"]
["Apricot Kernel",0.13500000000000001,{"$f":"B3*(56.1/39.99)","v":0.18938484621155291},0.94,null,null,{"$f":"IFERROR(IF(ISBLANK(E3),,E3/F3),0)","v":0}]
["Avocado",0.13300000000000001,0.18657914478619655,0.91500000000000004,null,null,{"$f":"IFERROR(IF(ISBLANK(E4),,E4/F4),0)","v":0}]
["Avocado Butter",0.13389999999999999,0.18784171042760689,0.90400000000000003,null,null,0]
["Babassu, brazil nut",0.17599999999999999,0.24690172543135783,0.89700000000000002,null,null,0]
["Beeswax",6.9000000000000006E-2,9.6796699174793707E-2,0.96585059576708199,null,null,0]
["Borage",0.13569999999999999,0.19036684171042759,0.92269999999999996,null,null,0]
["Brazil Nut",0.17499999999999999,0.24549887471867965,0.89700000000000002,null,null,0]
["Camellia",0.13619999999999999,0.19106826706676666,0.91500000000000004,null,null,0]
["Candelilla Wax",3.8100000000000002E-2,5.3448612153038262E-2,0.98399999999999999,null,null,0]
["Canola",0.13300000000000001,0.18657914478619655,0.91775844991975897,18,4000,4.4999999999999997E-3]
["Castor",0.128,0.17956489122280569,0.96499999999999997,45.5,5000,9.1000000000000004E-3]
["Chicken Fat",0.1389,0.19485596399099775,0.92400000000000004,null,null,0]
["Cocoa Butter",0.13700000000000001,0.19219054763690924,0.96799999999999997,36,1000,3.5999999999999997E-2]
["Coconut",0.183,0.25672168042010501,0.92400000000000004,29,5000,5.7999999999999996E-3]
["Cottonseed",0.1386,0.1944351087771943,0.91700000000000004,null,null,0]
["Evening Primrose",0.13569999999999999,0.19036684171042759,0.91400000000000003,null,null,0]
["Flaxseed",0.13569999999999999,0.19036684171042759,0.91500000000000004,null,null,0]
["Goose Fat",0.13689999999999999,0.19205026256564139,0.92877956667643702,null,null,0]
["Grapeseed",0.1265,0.17746061515378844,0.926775727266132,null,null,0]
["Hazelnut",0.1356,0.19022655663915977,0.91876036962491103,null,null,0]
["Hemp Seed",0.13450000000000001,0.18868342085521381,0.926775727266132,null,null,0]
["Jojoba (Wax)",6.9000000000000006E-2,9.6796699174793707E-2,1,null,null,0]
["Lanolin",7.4099999999999999E-2,0.10395123780945235,0.93799999999999994,null,null,0]
["Lard",0.13800000000000001,0.19359339834958741,0.92500000000000004,4.99,250,1.9960000000000002E-2]
["Linseed",0.13569999999999999,0.19036684171042759,0.91500000000000004,null,null,0]
["Macadamia",0.13900000000000001,0.19499624906226559,0.90400000000000003,null,null,0]
["Mango Butter",0.1371,0.19233083270817705,0.90300000000000002,34,1000,3.4000000000000002E-2]
["Meadowfoam",0.1207,0.16932408102025506,0.91,null,null,0]
["Mink",0.14000000000000001,0.19639909977494374,0.91220000000000001,null,null,0]
["Mustard",0.1241,0.17409377344336083,0.91500000000000004,null,null,0]
["Neat's foot",0.13589999999999999,0.19064741185296322,0.91675653021460601,null,null,0]
["Neem",0.13869999999999999,0.19457539384846209,0.92100000000000004,null,null,0]
["Not Used",0,0,0,null,null,0]
["Nutmeg Butter",0.11600000000000001,{"$f":"B36*(56.1/39.99)","v":0.16273068267066768},0.97186211399799805,null,null,0]
["Olive Pomace",0.13400000000000001,0.18798199549887473,0.92,14,4000,3.5000000000000001E-3]
["Olive",0.13400000000000001,0.18798199549887473,0.91800000000000004,24,4000,6.0000000000000001E-3]
["Palm",0.14199999999999999,0.19920480120030004,0.91500000000000004,24,4000,6.0000000000000001E-3]
["Palm Kernel",0.17899999999999999,0.25111027756939236,0.87,null,null,0]
["Palm, Stearic",0.14099999999999999,0.19780195048762189,0.94,null,null,0]
["Peach Kernel",0.13700000000000001,0.19219054763690924,0.91579999999999995,null,null,0]
["Peanut",0.13600000000000001,0.19078769692423106,0.91400000000000003,null,null,0]
["Perilla",0.13689999999999999,0.19205026256564139,0.93,null,null,0]
["Pistachio Nut",0.1328,0.18629857464366092,0.91300000000000003,null,null,0]
["Poppyseed",0.13830000000000001,0.19401425356339086,0.92500000000000004,null,null,0]
["Pumpkinseed",0.1431,0.20074793698424606,0.92400000000000004,null,null,0]
["Rapeseed",0.124,0.17395348837209301,0.91500000000000004,null,null,0]
["Rice Bran",0.128,0.17956489122280569,0.91800000000000004,20,3000,6.6666666666666671E-3]
["Rose Hip Seed",0.13780000000000001,0.19331282820705176,0.92,null,null,0]
["Safflower",0.13700000000000001,0.19219054763690924,0.92777764697128495,null,null,0]
["Sal Butter",0.13059999999999999,0.18321230307576894,0.89700000000000002,null,null,0]
["Sesame Seed",0.13300000000000001,0.18657914478619655,0.92076420903521605,null,null,0]
["Shea Butter",0.128,0.17956489122280569,0.9,19,1000,1.9E-2]
["Soybean",0.13500000000000001,0.18938484621155291,0.92700000000000005,null,null,0]
["Stearic Acid",0.14119999999999999,0.19808252063015752,0.94099999999999995,null,null,0]
["Sunflower Seed",0.13400000000000001,0.18798199549887473,0.92300000000000004,null,null,0]
["Sweet Almond",0.13600000000000001,0.19078769692423106,0.94879999999999998,20,1000,0.02]
["Tamanu",0.13569999999999999,0.19036684171042759,0.91,null,null,0]
["Walnut",0.1353,0.18980570142535635,0.92777764697128495,null,null,0]
["Wheatgerm",0.13100000000000001,0.18377344336084023,0.92500000000000004,null,null,0]
["Citric Acid (1.5%)",0.624,0.87537884471117777,null,4.1900000000000004,180,2.3277777777777779E-2]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,{"$f":"IFERROR(IF(ISBLANK(E68),,E68/F68),0)","v":0}]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,{"$f":"B100*(56.1/39.99)","v":0},null,null,null,0]

{"sheet":"Colourants","index":10,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Colours","Type","Brand","Supplier","Package Weight (g)","Package Cost","Cost / g"]
["Blue Oxide","Oxide","Aussie Soap Supplies","Aussie Soap Supplies",40,8,{"$f":"IF(ISBLANK(A2),,F2/E2)","v":0.2}]
["Fizzy Lemonade","Neon","Aussie Soap Supplies","Aussie Soap Supplies",20,7.5,0.375]
["Fuchsia","Neon","Aussie Soap Supplies","Aussie Soap Supplies",20,7.5,0.375]
["UltraViolet Blue","Neon","Aussie Soap Supplies","Aussie Soap Supplies",20,7.5,0.375]
["Tangerine Wow","Neon","Aussie Soap Supplies","Aussie Soap Supplies",20,7.5,0.375]
["Green Oxide","Oxide","Aussie Soap Supplies","Aussie Soap Supplies",40,8,0.2]
["Titanium Dioxide","Oxide","Escentials","Escentials",100,9,0.09]
["Liquid Dye Soap - Red","Water Soluble","Eroma","Eroma",25,5.83,0.23319999999999999]
["Liquid Dye Soap - Yellow","Water Soluble","Eroma","Eroma",25,5.83,0.23319999999999999]
["Liquid Dye Soap - Violet","Water Soluble","Eroma","Eroma",25,5.83,0.23319999999999999]
["Black Oxide","Oxide","Aussie Soap Supplies","Aussie Soap Supplies",40,8,0.2]
["Pearlescent Green","Mica","Amazon","Amazon",10,1.33,{"$f":"IF(ISBLANK(A13),,F13/E13)","v":0.13300000000000001}]
["Pearlescent Blue","Mica","Amazon","Amazon",10,1.33,{"$f":"IF(ISBLANK(A14),,F14/E14)","v":0.13300000000000001}]
["Pearlescent Black","Mica","Amazon","Amazon",10,1.33,{"$f":"IF(ISBLANK(A15),,F15/E15)","v":0.13300000000000001}]

{"sheet":"Lye","index":11,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Lye","Package Size","Package Cost","Cost / unit"]
["Sodium Hydroxide",5000,35.200000000000003,{"$f":"IFERROR(C2/B2,0)","v":7.0400000000000003E-3}]
["Potassium Hydroxide",500,25.85,5.1700000000000003E-2]

{"sheet":"Oils by Fatty Acids List","index":12,"n_rows":193,"n_cols":15,"rows_kept":193,"cut":false,"hidden":true,"merged":[]}
["Oil Name","Lauric","Myristic","Palmitic","Stearic","Ricinoleic","Oleic","Linoleic","Linolenic"]
["Sweet Almond",0,0,7,0,0,71,18,0]
["Apricot Kernel",0,0,6,0,0,66,27,0]
["Avocado",0,0,20,2,0,58,12,0]
["Avocado Butter",0,0,21,10,0,53,6,2]
["Babassu, brazil nut",50,20,11,4,0,10,0,0]
["Beeswax",0,0,0,0,0,0,0,0]
["Borage",0,0,10,4,0,20,43,5]
["Brazil Nut",0,0,13,11,0,39,36,0]
["Camelina",0,0,6,2,0,24,19,45]
["Camellia",0,0,9,2,0,77,8,0]
["Candelilla Wax",0,0,0,0,0,0,0,0]
["Canola",0,0,4,2,0,61,21,9]
["Castor",0,0,0,0,90,4,4,0]
["Chicken Fat",0,1,25,7,0,38,21,0]
["Cocoa Butter",0,0,28,33,0,35,3,0]
["Coconut",48,19,9,3,0,8,2,0]
["Corn",0,0,12,2,0,32,51,1]
["Cottonseed",0,0,13,13,0,18,52,1]
["Emu",0,0,23,9,0,47,8,0]
["Evening Primrose",0,0,0,0,0,0,80,9]
["Flaxseed",0,0,6,3,0,27,13,50]
["Goose Fat",0,0,21,6,0,54,10,0]
["Grapeseed",0,0,8,4,0,20,68,0]
["Hazelnut",0,0,5,3,0,75,10,0]
["Hemp Seed",0,0,6,2,0,12,57,21]
["Illipe Butter",0,0,17,45,0,35,0,0]
["Jojoba (Wax)",0,0,0,0,0,12,0,0]
["Kokum Butter",0,0,4,56,0,36,1,0]
["Kukui Nut",0,0,6,2,0,20,42,29]
["Lanolin",0,0,0,0,0,0,0,0]
["Lard",0,1,28,13,0,46,6,0]
["Linseed",0,0,6,3,0,27,13,50]
["Macadamia Oil",0,0,9,5,0,59,2,0]
["Mango Seed Oil",0,0,8,27,0,52,8,1]
["Mango Butter",0,0,7,42,0,45,3,0]
["Meadowfoam",0,0,0,0,0,0,0,0]
["Mink",0,0,0,0,0,0,0,0]
["Mustard",0,0,2,2,0,18,14,9]
["Neat's foot",0,0,0,0,0,0,0,0]
["Neem",0,2,21,16,0,46,12,0]
["Nutmeg Butter",3,83,4,0,0,5,0,0]
["Olive Pomace",0,0,14,3,0,69,12,2]
["Olive",0,0,14,3,0,69,12,1]
["Ostrich",3,1,26,6,0,37,17,3]
["Palm",0,1,44,5,0,39,10,0]
["Palm Kernel",49,16,8,2,0,15,3,0]
["Peach Kernel",0,0,6,2,0,65,25,1]
["Peanut",0,0,8,3,0,56,26,0]
["Perilla",0,0,6,2,0,15,16,56]
["Pistachio Nut",0,0,11,1,0,63,25,0]
["Poppyseed",0,0,10,2,0,17,69,2]
["Pumpkinseed",0,0,11,8,0,33,50,0]
["Rapeseed",0,0,0,0,0,17,13,9]
["Rice Bran",0,1,22,3,0,38,34,2]
["Rose Hip Seed",0,0,4,2,0,12,46,31]
["Safflower",0,0,7,0,0,15,75,0]
["Sal Butter",0,0,6,44,0,40,2,0]
["Sesame Seed",0,0,10,5,0,40,43,0]
["Shea Butter",0,0,5,40,0,48,6,0]
["Soybean",0,0,11,5,0,24,50,8]
["Stearic Acid",0,0,0,99,0,0,0,0]
["Sunflower Seed",0,0,7,4,0,16,70,1]
["Tallow, sheep",4,10,24,13,0,26,5,0]
["Tamanu",0,0,12,13,0,34,38,1]
["Walnut",0,0,7,2,0,18,60,0]
["Wheatgerm",0,0,17,2,0,17,58,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Hardness","Cleansing","Conditioning","Bubbly","Creamy"]
[null,null,null,null,null,null,null,null,null,"Olive",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"Coconut",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"Lard",{"$f":"SUM(B2:E2)","v":7},{"$f":"SUM(B2:C2)","v":0},{"$f":"SUM(F2:I2)","v":89},{"$f":"SUM(F2,B2:C2)","v":0},{"$f":"SUM(D2:F2)","v":7}]
[null,null,null,null,null,null,null,null,null,"Shea Butter",6,0,93,0,6]
[null,null,null,null,null,null,null,null,null,"Mango Butter",22,0,70,0,22]
[null,null,null,null,null,null,null,null,null,0,31,0,61,0,31]
[null,null,null,null,null,null,null,null,null,0,85,70,10,70,15]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Totals",14,0,68,0,14]
[null,null,null,null,null,null,null,null,null,null,24,0,75,0,24]
[null,null,null,null,null,null,null,null,null,null,8,0,88,0,8]
[null,null,null,null,null,null,null,null,null,null,11,0,85,0,11]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,6,0,91,0,6]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B14:E14)","v":0},{"$f":"SUM(B14:C14)","v":0},{"$f":"SUM(F14:I14)","v":98},{"$f":"SUM(F14,B14:C14)","v":90},{"$f":"SUM(D14:F14)","v":90}]
[null,null,null,null,null,null,null,null,null,null,33,1,59,1,32]
[null,null,null,null,null,null,null,null,null,null,61,0,38,0,61]
[null,null,null,null,null,null,null,null,null,null,79,67,10,67,12]
[null,null,null,null,null,null,null,null,null,null,14,0,84,0,14]
[null,null,null,null,null,null,null,null,null,null,26,0,71,0,26]
[null,null,null,null,null,null,null,null,null,null,32,0,55,0,32]
[null,null,null,null,null,null,null,null,null,null,0,0,89,0,0]
[null,null,null,null,null,null,null,null,null,null,9,0,90,0,9]
[null,null,null,null,null,null,null,null,null,null,27,0,64,0,27]
[null,null,null,null,null,null,null,null,null,null,12,0,88,0,12]
[null,null,null,null,null,null,null,null,null,null,8,0,85,0,8]
[null,null,null,null,null,null,null,null,null,null,8,0,90,0,8]
[null,null,null,null,null,null,null,null,null,null,62,0,35,0,62]
[null,null,null,null,null,null,null,null,null,null,0,0,12,0,0]
[null,null,null,null,null,null,null,null,null,null,60,0,37,0,60]
[null,null,null,null,null,null,null,null,null,null,8,0,91,0,8]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,42,1,52,1,41]
[null,null,null,null,null,null,null,null,null,null,9,0,90,0,9]
[null,null,null,null,null,null,null,null,null,null,14,0,61,0,14]
[null,null,null,null,null,null,null,null,null,null,35,0,61,0,35]
[null,null,null,null,null,null,null,null,null,null,49,0,48,0,49]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,4,0,41,0,4]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B40:E40)","v":0},{"$f":"SUM(B40:C40)","v":0},{"$f":"SUM(F40:I40)","v":0},{"$f":"SUM(F40,B40:C40)","v":0},{"$f":"SUM(D40:F40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B41:E41)","v":39},{"$f":"SUM(B41:C41)","v":2},{"$f":"SUM(F41:I41)","v":58},{"$f":"SUM(F41,B41:C41)","v":2},{"$f":"SUM(D41:F41)","v":37}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B42:E42)","v":90},{"$f":"SUM(B42:C42)","v":86},{"$f":"SUM(F42:I42)","v":5},{"$f":"SUM(F42,B42:C42)","v":86},{"$f":"SUM(D42:F42)","v":4}]
[null,null,null,null,null,null,null,null,null,null,17,0,83,0,17]
[null,null,null,null,null,null,null,null,null,null,17,0,82,0,17]
[null,null,null,null,null,null,null,null,null,null,36,4,57,4,32]
[null,null,null,null,null,null,null,null,null,null,50,1,49,1,49]
[null,null,null,null,null,null,null,null,null,null,75,65,18,65,10]
[null,null,null,null,null,null,null,null,null,null,8,0,91,0,8]
[null,null,null,null,null,null,null,null,null,null,11,0,82,0,11]
[null,null,null,null,null,null,null,null,null,null,8,0,87,0,8]
[null,null,null,null,null,null,null,null,null,null,12,0,88,0,12]
[null,null,null,null,null,null,null,null,null,null,12,0,88,0,12]
[null,null,null,null,null,null,null,null,null,null,19,0,83,0,19]
[null,null,null,null,null,null,null,null,null,null,0,0,39,0,0]
[null,null,null,null,null,null,null,null,null,null,26,1,74,1,25]
[null,null,null,null,null,null,null,null,null,null,6,0,89,0,6]
[null,null,null,null,null,null,null,null,null,null,7,0,90,0,7]
[null,null,null,null,null,null,null,null,null,null,50,0,42,0,50]
[null,null,null,null,null,null,null,null,null,null,15,0,83,0,15]
[null,null,null,null,null,null,null,null,null,null,45,0,54,0,45]
[null,null,null,null,null,null,null,null,null,null,16,0,82,0,16]
[null,null,null,null,null,null,null,null,null,null,99,0,0,0,99]
[null,null,null,null,null,null,null,null,null,null,11,0,87,0,11]
[null,null,null,null,null,null,null,null,null,null,51,14,31,14,37]
[null,null,null,null,null,null,null,null,null,null,25,0,73,0,25]
[null,null,null,null,null,null,null,null,null,null,9,0,78,0,9]
[null,null,null,null,null,null,null,null,null,null,19,0,75,0,19]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B74:E74)","v":0},{"$f":"SUM(B74:C74)","v":0},{"$f":"SUM(F74:I74)","v":0},{"$f":"SUM(F74,B74:C74)","v":0},{"$f":"SUM(D74:F74)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]